package com.hp.attendance.dao;

import com.hp.attendance.entity.dto.ExcelDTO;
import com.hp.attendance.util.BaseDAO;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

public class ExcelDao extends BaseDAO {

    public List<ExcelDTO>  getList(String tableName) throws SQLException, IOException, ClassNotFoundException, InstantiationException, IllegalAccessException {
        String sql="select column_name,column_comment from information_schema.`COLUMNS` " +
                "where table_name=? and table_schema='attendance'";
        Object[] obj ={tableName};
        List<ExcelDTO> list = queryList(sql, obj, new ExcelDTO());
        return list;
    }
}
